The target variable contains the result of the source expression calculation. Data is placed in the target after the calculation is performed. The data is maintained in the target until you replace it via another statement. Any script that uses a target value always uses the last value received by that target. This lets you reuse target values.
Target variable names are not case sensitive. Mixed case has no affect on how the name is processed or read during a calculation. Mixed case can be used for clarity. A target name cannot be a reserved keyword. A target’s type is designated by the first character of its assigned name. Target variables are one of these types:
Each type is explained below.
String Target Variables
String target variable names start with a letter (a- z). The name can be up to 20 characters in length. The remaining characters in the name can be any upper- or lowercase letter, number, the underscore (_), or percent sign (%). Here are some examples:
First_Name = "John"
LASTNAME = "Graham"
LAST_NAME = "Graham"
CompanyName = "Oracle"
The value received by a string target variable can be from zero to 255 ASCII characters in length.
Decimal Target Variables
Decimal target variable names start with a dollar sign ($). The name can be up to 20 characters in length. The remaining characters in the name can be any upper- or lowercase letter, number, the underscore (_), or percent sign (%). Here are some examples:
$BEGIN_BAL = 100.00
$Final_Balance = 00.00
Decimal target variables receive numeric values with decimals. The values in these fields can contain up to 14 digits and a decimal.
Integer Target Variables
Integer target variable names start with a pound sign (#). The name can be up to 20 characters in length. The remaining characters in the name can be any upper- or lowercase letter, number, the underscore (_), or percent sign (%). Here are some examples:
#Employees = 3000
#Number_of_Insured = 2300
#%Insured = (#Number_of_Insured / #Employees * 100)
Integer target variables receive numeric values as whole numbers — no decimals. The values in these fields can range from plus or minus two billion.
© Copyright 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices